home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Software Vault: The Gold Collection
/
Software Vault - The Gold Collection (American Databankers) (1993).ISO
/
cdr09
/
fru_db3i.zip
/
FRU-DB3I.DOC
< prev
Wrap
Text File
|
1993-06-17
|
6KB
|
105 lines
FRU-DB3I.DOC For use with PAF 2.2 and dBASE III or compatible programs only.
!!! NOT TESTED WITH ANY OTHER VERSIONS OF THESE PROGRAMS !!!
ALSO - If you have a dbase .dbf file named FR-IND.DBF or PAF-IND.DBF you should
rename those files immediately, before proceeding with this utility. This
utility will create new files of the same names and will overwrite your old
files. End of warnings, relax, take a deep breath and read the following
thoroughly before doing anything:
The FRU.ZIP program offers the PAF user the utility to convert records to ASCII
text format in delimited form. That is to say that the PAF data records are
converted into individual lines in a text file. Using the "D" option for the
delimited form, thus having each field of each record separated by a comma, the
file is readable by dbase III. To do this you need a database file with the
proper field names imbedded and a command line to get the ASCII text delimited
file read into the database (.dbf) file.
I have created the two items necessary to automate this process, and thus
you can bring 500 individual's records into a dbase-ready file in about 20
minutes or less (with practice you can get it down to about 5 to 7 minutes
depending on the speed of your pc and the size of your paf\data files).
PROCEDURE: Included with this instruction file (FRU-DB3I.doc) are:
FR-IND.DBF The pre-structured dbase database file for PAF data
which will create your PAF-IND.DBF file. (This file
PAF-IND.DBF, will will contain your data)
FR-INPUT.PRG The necessary command line to import the data
1. Copy the FRU-DB3I.ZIP file into your dbase directory
type PKUNZIP FRU-DB3I.ZIP and press the enter key.
The zip file will then expand and extract the three files
in this utility. They are FRU-DB3I.DOC, FRU-IND.DBF, and
FR-INPUT.PRG (The PAF-IND.DBF file will be created in dbase)
( You must have the pkzip programs to do this. If you do not
have these wonderful archiving utilities you may download them
from virtually any BBS board in the country. Look for PKZIP.EXE
or some variation, as long as the PKZIP letters are in the file
you have the right files).
2. From the FRU.EXE utility program (or any PAF utility that will
create a true ASCII text file in true comma delimited form from
the original PAF data file), select the option to Convert Family
Records Data To ASCII, select option 5 from the FRU main menu.
3. For record type answer D for individual file answer Y
For marriage, note and event files answer N
( I will try and have the automated conversions ready for
the marriage file in about a week from now. It will be
called FRU-DB3M.ZIP)
4. The FRU.EXE program will create a file called FR.IND that is
the ASCII text file of all individual records you have in your
PAF data files. When completed, exit the FRU program.
5. Copy the FR.IND file into your dbase III directory
6. Enter your dbase program
7. At the dot prompt (the command line in some dbase compatible
programs) type USE FR-IND and then press the enter key.
Once the database file is loaded into your dbase program
then just type DO FR-INPUT and press the enter key.
This will run the FR-INPUT.PRG file that gives the instruction
your dbase program to "append from fr.ind type delimited"
which will cause dbase to read the fr.ind text file into the
FR-IND.DBF database file automatically. It will then copy the
new fr-ind.dbf file with all data to a secondary file called
paf-ind.dbf then it will delete all the records from fr-ind.dbf
so that it may be used again for another inputting.
8. You now have all your records in the proper dbase format ready
to create reports or print formats with.
To use your data just type CLOSE ALL
Then type USE PAF-IND
Then type ASSIST to create your report formats.
REMEMBER: The FR-IND.DBF file that originally accepted all
the data is now empty. All your data is in PAF-IND.DBF. You may,
of course, rename the PAF-IND.DBF file any name you wish as long
as you leave the .dbf extension on the filename. For example I
usually rename the PAF-IND.DBF file something that tells me the
date of the data, so I might name it PAF-0691.DBF so I can tell
it is the PAF data from June of 1991.
9. You should have been able to accomplish all of this in less than
twenty minutes, and most of it was automated.
10. Admission of failure:
I had some difficulty figuring out about 8 of the PAF file
fields, so I named them UNKNOWN1...UNKNOWN8. You can very
easilly rename them to what they should be (if you need them
renamed) by using the modify structure command from within
dbase or using the ASSIST program and modifying the structure
from there. You probaby won't need to modify these fields at all.
Bob Christopher
(303) 369-8902
Denver, Colorado
June 17, 1991